$id_query = "SELECT name FROM ideas where member_id = '$viewid' order by pos";
$id_result = mysql_db_query($db, $id_query);
$ideas = mysql_num_rows($id_result);
if ($ideas > 0) {
?>
General Gift Ideas: (Likes, Interests)
if ($id_result) {
while ($r = mysql_fetch_array($id_result)) {
$name = $r["name"];
echo "$name | ";
} mysql_free_result($id_result);
} else { echo "Error retrieving"; }
echo "
";
}
?>
$ce_query = "SELECT name FROM cert where member_id = '$viewid' order by pos";
$ce_result = mysql_db_query($db, $ce_query);
$ideas = mysql_num_rows($ce_result);
if ($ideas > 0) {
?>
Preferred Gift Certificates:
if ($ce_result) {
while ($r = mysql_fetch_array($ce_result)) {
$name = $r["name"];
echo "$name | ";
} mysql_free_result($ce_result);
} else { echo "Error retrieving"; }
echo "
";
}
?>
$ch_query = "SELECT name FROM charity where member_id = '$viewid' order by pos";
$ch_result = mysql_db_query($db, $ch_query);
$ideas = mysql_num_rows($ch_result);
if ($ideas > 0) {
?>
Donate4Me Preferred Charities:
if ($ch_result) {
while ($r = mysql_fetch_array($ch_result)) {
$name = $r["name"];
echo "$name | ";
} mysql_free_result($ch_result);
} else { echo "Error retrieving"; }
echo " ";
}
?>
| |
NOTE: Click the 'Status' button to see if this item has been marked as bought, or to mark it as bought. |
|
Picture/Link |
Description/Link |
Retailers |
Price Range |
Rank |
Options |
$query = "SELECT * FROM gifts where member_id = '$viewid' order by $sort";
$result = mysql_db_query($db, $query);
$records = mysql_num_rows($result);
if ($records == 0) {echo "There are no gift entries on $viewid's Wonderlist.";}
# if ($records == 1) {echo "Found 1 gift entry on $viewid's Wonderlist. ";}
# if ($records > 1) {echo "Found $records gift entries on $viewid's Wonderlist: ";}
if ($result) {
while ($r = mysql_fetch_array($result)) {
$date = $r["date_added"];
$descr = $r["description"];
$link = $r["link"];
$image = $r["image"];
$retailer = $r["retailer"];
$price = $r["price"];
if ($price == '1') { $dprice = 'not specified'; }
if ($price == '2') { $dprice = '$20 or less'; }
if ($price == '3') { $dprice = '$20-$50'; }
if ($price == '4') { $dprice = '$50-$75'; }
if ($price == '5') { $dprice = '$75-$100'; }
if ($price == '6') { $dprice = '$100 or more'; }
$entry_id = $r["entry_id"];
$rank = $r["rank"];
if ($rank == "not specified") {$rank = "none";}
if ($link != "") {
if (strpos($link, "http") !== 0) {$link = "http://$link";}
} else {$link = "None";}
if ($image == "") {$image = "images/none.bmp";}
$image_size=getimagesize($image);
if ($image_size[0] > $image_size[1]) {
$width = 100;
$height = 100/($image_size[0]/$image_size[1]);
} else {
$height = 100;
$width = 100/($image_size[1]/$image_size[0]);
}
echo "
| ";
if ($link == "None") {
echo " | $descr | $retailer | $dprice | $rank | ";
} else {
echo " | $descr | $retailer | $dprice | $rank | ";
}
echo "";
# FORM FOR -MARK AS BOUGHT- IS BELOW, NOT COMPLETED
echo "";
echo " | ";
}
echo "";
} else {
echo "No gifts on $viewid's list. ";
}
mysql_free_result($result);
?>
|